General lookup/validation tables

Creating general lookup/validation tables  PAGEREF _Toc336858610 \h 1

Set up general lookup/validation window  4

Reference to general lookup/validation tables  6

ACCESS_KEYWORDS (Validation) 7

ADDRESS_PURPOSE (Validation) 7

APPEAL_TYPE  (Validation) 8

BAD_ADDRESS (Validation) 8

BADGE_TYPES (Validation) 9

CATEGORY (Validation) 9

CEU_TYPE (Required Validation) 9

COMMITTEE_GROUP (Validation) 10

COMMITTEE_STS (Required Validation) 10

CONFLICT_CODE (Validation) 10

CONTACT_TYPE (Validation) 11

COUNTRY  (Validation, Expansion) 11

DESIGNATION (Expansion only) 11

EXPENSE_TYPE (Validation, Expansion) 11

EXPO_CAT (Validation) 11

EXPO_PROD_CAT (Validation) 12

FUNC_TITLE (Validation) 12

FUNDRAISER_TYPE (Validation) 12

GIFT_AMOUNT (Lookup only) 13

GL_ACCOUNT (Validation) 13

GROUP_CODE (Validation) 14

HOLD_CODES (Lookup only) 15

LOCATION (Lookup only) 15

MAIL_CODE (Lookup only) 15

MEETING_TYPE (Lookup only) 16

MEM_TRIB_RELATIONSHIP (Validation) 16

MEMBER_STATUS (Required Validation) 16

MERGE_CODE (Validation) 16

NOTE_PURPOSE (Validation) 17

PREFIX (Validation) 17

REFERRAL_AREA (Validation) 18

REQUEST_STATUS (Validation) 18

REQUEST_TYPE (Validation) 18

SALUTATION_CODE (Validation) 18

SHIP_METHOD (Required Validation) 19

SIC_CODE (Validation) 19

SOURCE_CODE (Validation) 20

SR_AREA (Validation) 21

SR_CAT (Validation) 21

SR_ENVIRON (Validation) 21

SR_CATLEVEL (Validation) 21

SR_CNTTYPE (Validation) 22

SR_RES (Required Validation) 22

SR_SRVTYPE (Required Validation) 22

SR_SYS (Validation) 22

SR_VERSION (Validation) 23

STATE (Validation) 23

SUFFIX (Validation) 23

TITLE (Validation/Lookup) 23

ZIP3 (Validation) 24